﻿-- =============================================
-- Script Template
-- =============================================


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Ivy_Sys_RoleMaster]'
GO

		SET IDENTITY_INSERT [Sys_RoleMaster] ON
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, N'SYSSPRADM', N'System Super Admin', N'Super Administrator for the Portal', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'SYSADMIN', N'System Admin', N'Administrator for the Portal', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'SYSREGUSR', N'System Registered User', N'User registered with the Portal', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		SET IDENTITY_INSERT [Sys_RoleMaster] OFF